<?php
class Model_DbTable_ProductCategory extends Apps_Db_Table_Abstract {
	protected $_name = 'product_category';

	const STATUS_ACTIVE   = 1;
	const STATUS_INACTIVE = 0;
	const STATUS_DELETED  = -1;

	const SHOW_HOME       = 1;
	const NOT_SHOW_HOME   = 0;


	//LIST
	public function getList () {
		$q = $this->_db
				  ->select()
				  ->from($this->_name, null)
				  ->where('status =?', self::STATUS_ACTIVE)
				  ->order($this->_name . '.title')
				  ->columns(array('id'			    => 'id',
				 				  'title'		    => 'title',
				 				  'status'	        => 'status',
				 				  'sorting_number'	=> 'sorting_number',
				  				  'created_date'    => 'created_date'));
 		return $q;
	}

	public function listParentCategory() {
		$q = $this->_db
				  ->select()
				  ->from($this->_name, null)
				  ->where('status =?', self::STATUS_ACTIVE)
				  ->where('parent_id =?', 0)
				  ->order('sorting_number ASC')
				  ->columns(array('id'			    => 'id',
				 				  'title'		    => 'title'));

 		return $q->query()->fetchAll();
	}

	public function listChildCategory($parentId) {
		$q = $this->_db
				  ->select()
				  ->from($this->_name, null)
				  ->where('status =?', self::STATUS_ACTIVE)
				  ->where('parent_id =?', $parentId)
				  ->order('sorting_number ASC')
				  ->columns(array('id'			    => 'id',
				 				  'title'		    => 'title'));

 		return $q->query()->fetchAll();
	}


}